select  * from GLCoverage c 
where c.CoverageId in 
(select ca.CoverageId from GLCoverageApplicable ca 
INNER join GLClub cl on cl.ClubId =ca.ClubId 
where cl.ClubName like clubname
group by ca.CoverageId) 

select  * from GLCoverage c 
where c.CoverageId in 
(select ca.CoverageId from GLCoverageApplicable ca 
INNER join GL cl on cl.ClubId =ca.ClubId 
where cl.ClubName like '%Europe%' 
group by ca.CoverageId) 

select  * from GLCoverage 
where DeactiveYN = 'N' and and cl.DeactiveYN ='N'
order by c.CoverageName


select * from GLCoverageApplicable ca 
INNER join GLClub cl on cl.ClubId =ca.ClubId 
where cl.ClubName like '%Europe%'

select *  from GLClub where ClubGroupID like 'SC' and DeactiveYN = 'N'